﻿<?xml version="1.0"?>
<ModelDefinition xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<ClientName>dotNetProfessioanl.com</ClientName>
	<CopyrightNotice>Copywright 2008 $ClientName$</CopyrightNotice>
	<ModelName>Northwind</ModelName>
	<RootPath>c:\temp\modeltest\$ModelName$</RootPath>
	<RootNamespace>$ClientName$.$ModelName$</RootNamespace>

	<DomainDefinition>
		<ModelConnectionString>Data Source=.;Initial Catalog=Northwind;Integrated Security=true;Connection Timeout=1;</ModelConnectionString>
		<ResolveLooseRelationships>false</ResolveLooseRelationships>
		<DomainNamespace>$Entity.Domain.RootNamespace$.Business.Entities.$Entity.RelativeNamespace$</DomainNamespace>
		<ManyToManyRuleDefinition>
			<ManyToManyRuleDefinition SourceObjectName="ModifiedDate"/>
			<ManyToManyRuleDefinition SourceObjectName="rowguid"/>
		</ManyToManyRuleDefinition>
		<BaseEntityClass>
			<ClassName></ClassName>
			<Namespace></Namespace>
			<Attributes>
				<!-- Role Types: None, PrimaryKey, ConcurrencyKey, CreatedBy, ModifiedBy, CreatedDate, ModifiedDate, IsValid, IsDirty-->
				<BusinessEntityAttribute Name="ModifiedDate" AttributeRole="ModifiedDate"/>
				<BusinessEntityAttribute Name="rowguid" AttributeRole="ConcurrencyKey"/>
			</Attributes>
		</BaseEntityClass>

		<Entities>
			<EntityDefinition Name="Category" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Categories" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="CategoryID" SourceObjectName="CategoryID" Visible="true"/>
					<PropertyDefinition Name="CategoryName" SourceObjectName="CategoryName" Visible="true"/>
					<PropertyDefinition Name="Description" SourceObjectName="Description" Visible="true"/>
					<PropertyDefinition Name="Picture" SourceObjectName="Picture" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="CategoryName" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="Products" RelationshipType="OneToMany" SourceObjectName="FK_Products_Categories" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="CustomerDemographic" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Reference" SourceObjectName="dbo.CustomerDemographics" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="CustomerTypeID" SourceObjectName="CustomerTypeID" Visible="true"/>
					<PropertyDefinition Name="CustomerDesc" SourceObjectName="CustomerDesc" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="CustomerTypeID" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="Customers" RelationshipType="ManyToMany" SourceObjectName="FK_CustomerCustomerDemo" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Customer" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Customers" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="CustomerID" SourceObjectName="CustomerID" Visible="true"/>
					<PropertyDefinition Name="CompanyName" SourceObjectName="CompanyName" Visible="true"/>
					<PropertyDefinition Name="ContactName" SourceObjectName="ContactName" Visible="true"/>
					<PropertyDefinition Name="ContactTitle" SourceObjectName="ContactTitle" Visible="true"/>
					<PropertyDefinition Name="Address" SourceObjectName="Address" Visible="true"/>
					<PropertyDefinition Name="City" SourceObjectName="City" Visible="true"/>
					<PropertyDefinition Name="Region" SourceObjectName="Region" Visible="true"/>
					<PropertyDefinition Name="PostalCode" SourceObjectName="PostalCode" Visible="true"/>
					<PropertyDefinition Name="Country" SourceObjectName="Country" Visible="true"/>
					<PropertyDefinition Name="Phone" SourceObjectName="Phone" Visible="true"/>
					<PropertyDefinition Name="Fax" SourceObjectName="Fax" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="CompanyName" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="CustomerTypes" RelationshipType="ManyToMany" SourceObjectName="FK_CustomerCustomerDemo_Customers" Visible="true"/>
					<RelationshipDefinition Name="Orders" RelationshipType="OneToMany" SourceObjectName="FK_Orders_Customers" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Employee" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Employees" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="EmployeeID" SourceObjectName="EmployeeID" Visible="true"/>
					<PropertyDefinition Name="LastName" SourceObjectName="LastName" Visible="true"/>
					<PropertyDefinition Name="FirstName" SourceObjectName="FirstName" Visible="true"/>
					<PropertyDefinition Name="Title" SourceObjectName="Title" Visible="true"/>
					<PropertyDefinition Name="TitleOfCourtesy" SourceObjectName="TitleOfCourtesy" Visible="true"/>
					<PropertyDefinition Name="BirthDate" SourceObjectName="BirthDate" Visible="true"/>
					<PropertyDefinition Name="HireDate" SourceObjectName="HireDate" Visible="true"/>
					<PropertyDefinition Name="Address" SourceObjectName="Address" Visible="true"/>
					<PropertyDefinition Name="City" SourceObjectName="City" Visible="true"/>
					<PropertyDefinition Name="Region" SourceObjectName="Region" Visible="true"/>
					<PropertyDefinition Name="PostalCode" SourceObjectName="PostalCode" Visible="true"/>
					<PropertyDefinition Name="Country" SourceObjectName="Country" Visible="true"/>
					<PropertyDefinition Name="HomePhone" SourceObjectName="HomePhone" Visible="true"/>
					<PropertyDefinition Name="Extension" SourceObjectName="Extension" Visible="true"/>
					<PropertyDefinition Name="Photo" SourceObjectName="Photo" Visible="true"/>
					<PropertyDefinition Name="Notes" SourceObjectName="Notes" Visible="true"/>
					<PropertyDefinition Name="ReportsTo" SourceObjectName="ReportsTo" Visible="true"/>
					<PropertyDefinition Name="PhotoPath" SourceObjectName="PhotoPath" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="EmployeeID" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="EmployeeReportsToes" RelationshipType="OneToMany" SourceObjectName="FK_Employees_Employees1toM" Visible="true"/>
					<RelationshipDefinition Name="ReportsTo" RelationshipType="Recursive" SourceObjectName="FK_Employees_Employees" Visible="true"/>
					<RelationshipDefinition Name="Territories" RelationshipType="ManyToMany" SourceObjectName="FK_EmployeeTerritories_Employees" Visible="true"/>
					<RelationshipDefinition Name="Orders" RelationshipType="OneToMany" SourceObjectName="FK_Orders_Employees" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="OrderDetail" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Order Details" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="ProductID" SourceObjectName="ProductID" Visible="true"/>
					<PropertyDefinition Name="UnitPrice" SourceObjectName="UnitPrice" Visible="true"/>
					<PropertyDefinition Name="Quantity" SourceObjectName="Quantity" Visible="true"/>
					<PropertyDefinition Name="Discount" SourceObjectName="Discount" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="OrderID" />
					<BusinessKeyDefinition SourceObjectName="ProductID" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="Order" RelationshipType="ManyToOne" SourceObjectName="FK_Order_Details_Orders" Visible="true"/>
					<RelationshipDefinition Name="Product" RelationshipType="ManyToOne" SourceObjectName="FK_Order_Details_Products" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Order" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Orders" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="CustomerID" SourceObjectName="CustomerID" Visible="true"/>
					<PropertyDefinition Name="EmployeeID" SourceObjectName="EmployeeID" Visible="true"/>
					<PropertyDefinition Name="OrderDate" SourceObjectName="OrderDate" Visible="true"/>
					<PropertyDefinition Name="RequiredDate" SourceObjectName="RequiredDate" Visible="true"/>
					<PropertyDefinition Name="ShippedDate" SourceObjectName="ShippedDate" Visible="true"/>
					<PropertyDefinition Name="ShipVia" SourceObjectName="ShipVia" Visible="true"/>
					<PropertyDefinition Name="Freight" SourceObjectName="Freight" Visible="true"/>
					<PropertyDefinition Name="ShipName" SourceObjectName="ShipName" Visible="true"/>
					<PropertyDefinition Name="ShipAddress" SourceObjectName="ShipAddress" Visible="true"/>
					<PropertyDefinition Name="ShipCity" SourceObjectName="ShipCity" Visible="true"/>
					<PropertyDefinition Name="ShipRegion" SourceObjectName="ShipRegion" Visible="true"/>
					<PropertyDefinition Name="ShipPostalCode" SourceObjectName="ShipPostalCode" Visible="true"/>
					<PropertyDefinition Name="ShipCountry" SourceObjectName="ShipCountry" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="OrderID" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="OrderDetails" RelationshipType="OneToMany" SourceObjectName="FK_Order_Details_Orders" Visible="true"/>
					<RelationshipDefinition Name="Customer" RelationshipType="ManyToOne" SourceObjectName="FK_Orders_Customers" Visible="true"/>
					<RelationshipDefinition Name="Employee" RelationshipType="ManyToOne" SourceObjectName="FK_Orders_Employees" Visible="true"/>
					<RelationshipDefinition Name="ShipVia" RelationshipType="ManyToOne" SourceObjectName="FK_Orders_Shippers" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Product" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Products" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="ProductID" SourceObjectName="ProductID" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="SupplierID" SourceObjectName="SupplierID" Visible="true"/>
					<PropertyDefinition Name="CategoryID" SourceObjectName="CategoryID" Visible="true"/>
					<PropertyDefinition Name="QuantityPerUnit" SourceObjectName="QuantityPerUnit" Visible="true"/>
					<PropertyDefinition Name="UnitPrice" SourceObjectName="UnitPrice" Visible="true"/>
					<PropertyDefinition Name="UnitsInStock" SourceObjectName="UnitsInStock" Visible="true"/>
					<PropertyDefinition Name="UnitsOnOrder" SourceObjectName="UnitsOnOrder" Visible="true"/>
					<PropertyDefinition Name="ReorderLevel" SourceObjectName="ReorderLevel" Visible="true"/>
					<PropertyDefinition Name="Discontinued" SourceObjectName="Discontinued" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="ProductName" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="OrderDetails" RelationshipType="OneToMany" SourceObjectName="FK_Order_Details_Products" Visible="true"/>
					<RelationshipDefinition Name="Category" RelationshipType="ManyToOne" SourceObjectName="FK_Products_Categories" Visible="true"/>
					<RelationshipDefinition Name="Supplier" RelationshipType="ManyToOne" SourceObjectName="FK_Products_Suppliers" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Region" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Region" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="RegionID" SourceObjectName="RegionID" Visible="true"/>
					<PropertyDefinition Name="RegionDescription" SourceObjectName="RegionDescription" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="RegionDescription" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="Territories" RelationshipType="OneToMany" SourceObjectName="FK_Territories_Region" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Shipper" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Shippers" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="ShipperID" SourceObjectName="ShipperID" Visible="true"/>
					<PropertyDefinition Name="CompanyName" SourceObjectName="CompanyName" Visible="true"/>
					<PropertyDefinition Name="Phone" SourceObjectName="Phone" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="CompanyName" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="OrderShipVias" RelationshipType="OneToMany" SourceObjectName="FK_Orders_Shippers" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Supplier" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Suppliers" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="SupplierID" SourceObjectName="SupplierID" Visible="true"/>
					<PropertyDefinition Name="CompanyName" SourceObjectName="CompanyName" Visible="true"/>
					<PropertyDefinition Name="ContactName" SourceObjectName="ContactName" Visible="true"/>
					<PropertyDefinition Name="ContactTitle" SourceObjectName="ContactTitle" Visible="true"/>
					<PropertyDefinition Name="Address" SourceObjectName="Address" Visible="true"/>
					<PropertyDefinition Name="City" SourceObjectName="City" Visible="true"/>
					<PropertyDefinition Name="Region" SourceObjectName="Region" Visible="true"/>
					<PropertyDefinition Name="PostalCode" SourceObjectName="PostalCode" Visible="true"/>
					<PropertyDefinition Name="Country" SourceObjectName="Country" Visible="true"/>
					<PropertyDefinition Name="Phone" SourceObjectName="Phone" Visible="true"/>
					<PropertyDefinition Name="Fax" SourceObjectName="Fax" Visible="true"/>
					<PropertyDefinition Name="HomePage" SourceObjectName="HomePage" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="CompanyName" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="Products" RelationshipType="OneToMany" SourceObjectName="FK_Products_Suppliers" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Territory" RelativeNamespace="" IsAbstract="false" IsUpdatable="true" EntityType="Entity" SourceObjectName="dbo.Territories" SourceObjectType="Table" Visible="true">
				<Properties>
					<PropertyDefinition Name="TerritoryID" SourceObjectName="TerritoryID" Visible="true"/>
					<PropertyDefinition Name="TerritoryDescription" SourceObjectName="TerritoryDescription" Visible="true"/>
					<PropertyDefinition Name="RegionID" SourceObjectName="RegionID" Visible="true"/>
				</Properties>
				<BusinessKeys>
					<BusinessKeyDefinition SourceObjectName="TerritoryDescription" />
					<BusinessKeyDefinition SourceObjectName="RegionID" />
				</BusinessKeys>
				<Relationships>
					<RelationshipDefinition Name="Employees" RelationshipType="ManyToMany" SourceObjectName="FK_EmployeeTerritories_Territories" Visible="true"/>
					<RelationshipDefinition Name="Region" RelationshipType="ManyToOne" SourceObjectName="FK_Territories_Region" Visible="true"/>
				</Relationships>
			</EntityDefinition>
			<EntityDefinition Name="Alphabeticallistofproducts" RelativeNamespace="" SourceObjectName="dbo.Alphabetical list of products" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="ProductID" SourceObjectName="ProductID" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="SupplierID" SourceObjectName="SupplierID" Visible="true"/>
					<PropertyDefinition Name="CategoryID" SourceObjectName="CategoryID" Visible="true"/>
					<PropertyDefinition Name="QuantityPerUnit" SourceObjectName="QuantityPerUnit" Visible="true"/>
					<PropertyDefinition Name="UnitPrice" SourceObjectName="UnitPrice" Visible="true"/>
					<PropertyDefinition Name="UnitsInStock" SourceObjectName="UnitsInStock" Visible="true"/>
					<PropertyDefinition Name="UnitsOnOrder" SourceObjectName="UnitsOnOrder" Visible="true"/>
					<PropertyDefinition Name="ReorderLevel" SourceObjectName="ReorderLevel" Visible="true"/>
					<PropertyDefinition Name="Discontinued" SourceObjectName="Discontinued" Visible="true"/>
					<PropertyDefinition Name="CategoryName" SourceObjectName="CategoryName" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="CategorySalesfor1997" RelativeNamespace="" SourceObjectName="dbo.Category Sales for 1997" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="CategoryName" SourceObjectName="CategoryName" Visible="true"/>
					<PropertyDefinition Name="CategorySales" SourceObjectName="CategorySales" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="CurrentProductList" RelativeNamespace="" SourceObjectName="dbo.Current Product List" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="ProductID" SourceObjectName="ProductID" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="CustomerandSuppliersbyCity" RelativeNamespace="" SourceObjectName="dbo.Customer and Suppliers by City" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="City" SourceObjectName="City" Visible="true"/>
					<PropertyDefinition Name="CompanyName" SourceObjectName="CompanyName" Visible="true"/>
					<PropertyDefinition Name="ContactName" SourceObjectName="ContactName" Visible="true"/>
					<PropertyDefinition Name="Relationship" SourceObjectName="Relationship" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="Invoices" RelativeNamespace="" SourceObjectName="dbo.Invoices" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="ShipName" SourceObjectName="ShipName" Visible="true"/>
					<PropertyDefinition Name="ShipAddress" SourceObjectName="ShipAddress" Visible="true"/>
					<PropertyDefinition Name="ShipCity" SourceObjectName="ShipCity" Visible="true"/>
					<PropertyDefinition Name="ShipRegion" SourceObjectName="ShipRegion" Visible="true"/>
					<PropertyDefinition Name="ShipPostalCode" SourceObjectName="ShipPostalCode" Visible="true"/>
					<PropertyDefinition Name="ShipCountry" SourceObjectName="ShipCountry" Visible="true"/>
					<PropertyDefinition Name="CustomerID" SourceObjectName="CustomerID" Visible="true"/>
					<PropertyDefinition Name="CustomerName" SourceObjectName="CustomerName" Visible="true"/>
					<PropertyDefinition Name="Address" SourceObjectName="Address" Visible="true"/>
					<PropertyDefinition Name="City" SourceObjectName="City" Visible="true"/>
					<PropertyDefinition Name="Region" SourceObjectName="Region" Visible="true"/>
					<PropertyDefinition Name="PostalCode" SourceObjectName="PostalCode" Visible="true"/>
					<PropertyDefinition Name="Country" SourceObjectName="Country" Visible="true"/>
					<PropertyDefinition Name="Salesperson" SourceObjectName="Salesperson" Visible="true"/>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="OrderDate" SourceObjectName="OrderDate" Visible="true"/>
					<PropertyDefinition Name="RequiredDate" SourceObjectName="RequiredDate" Visible="true"/>
					<PropertyDefinition Name="ShippedDate" SourceObjectName="ShippedDate" Visible="true"/>
					<PropertyDefinition Name="ShipperName" SourceObjectName="ShipperName" Visible="true"/>
					<PropertyDefinition Name="ProductID" SourceObjectName="ProductID" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="UnitPrice" SourceObjectName="UnitPrice" Visible="true"/>
					<PropertyDefinition Name="Quantity" SourceObjectName="Quantity" Visible="true"/>
					<PropertyDefinition Name="Discount" SourceObjectName="Discount" Visible="true"/>
					<PropertyDefinition Name="ExtendedPrice" SourceObjectName="ExtendedPrice" Visible="true"/>
					<PropertyDefinition Name="Freight" SourceObjectName="Freight" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="OrderDetailsExtended" RelativeNamespace="" SourceObjectName="dbo.Order Details Extended" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="ProductID" SourceObjectName="ProductID" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="UnitPrice" SourceObjectName="UnitPrice" Visible="true"/>
					<PropertyDefinition Name="Quantity" SourceObjectName="Quantity" Visible="true"/>
					<PropertyDefinition Name="Discount" SourceObjectName="Discount" Visible="true"/>
					<PropertyDefinition Name="ExtendedPrice" SourceObjectName="ExtendedPrice" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="OrderSubtotals" RelativeNamespace="" SourceObjectName="dbo.Order Subtotals" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="Subtotal" SourceObjectName="Subtotal" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="OrdersQry" RelativeNamespace="" SourceObjectName="dbo.Orders Qry" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="CustomerID" SourceObjectName="CustomerID" Visible="true"/>
					<PropertyDefinition Name="EmployeeID" SourceObjectName="EmployeeID" Visible="true"/>
					<PropertyDefinition Name="OrderDate" SourceObjectName="OrderDate" Visible="true"/>
					<PropertyDefinition Name="RequiredDate" SourceObjectName="RequiredDate" Visible="true"/>
					<PropertyDefinition Name="ShippedDate" SourceObjectName="ShippedDate" Visible="true"/>
					<PropertyDefinition Name="ShipVia" SourceObjectName="ShipVia" Visible="true"/>
					<PropertyDefinition Name="Freight" SourceObjectName="Freight" Visible="true"/>
					<PropertyDefinition Name="ShipName" SourceObjectName="ShipName" Visible="true"/>
					<PropertyDefinition Name="ShipAddress" SourceObjectName="ShipAddress" Visible="true"/>
					<PropertyDefinition Name="ShipCity" SourceObjectName="ShipCity" Visible="true"/>
					<PropertyDefinition Name="ShipRegion" SourceObjectName="ShipRegion" Visible="true"/>
					<PropertyDefinition Name="ShipPostalCode" SourceObjectName="ShipPostalCode" Visible="true"/>
					<PropertyDefinition Name="ShipCountry" SourceObjectName="ShipCountry" Visible="true"/>
					<PropertyDefinition Name="CompanyName" SourceObjectName="CompanyName" Visible="true"/>
					<PropertyDefinition Name="Address" SourceObjectName="Address" Visible="true"/>
					<PropertyDefinition Name="City" SourceObjectName="City" Visible="true"/>
					<PropertyDefinition Name="Region" SourceObjectName="Region" Visible="true"/>
					<PropertyDefinition Name="PostalCode" SourceObjectName="PostalCode" Visible="true"/>
					<PropertyDefinition Name="Country" SourceObjectName="Country" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="ProductSalesfor1997" RelativeNamespace="" SourceObjectName="dbo.Product Sales for 1997" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="CategoryName" SourceObjectName="CategoryName" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="ProductSales" SourceObjectName="ProductSales" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="ProductsAboveAveragePrice" RelativeNamespace="" SourceObjectName="dbo.Products Above Average Price" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="UnitPrice" SourceObjectName="UnitPrice" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="ProductsbyCategory" RelativeNamespace="" SourceObjectName="dbo.Products by Category" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="CategoryName" SourceObjectName="CategoryName" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="QuantityPerUnit" SourceObjectName="QuantityPerUnit" Visible="true"/>
					<PropertyDefinition Name="UnitsInStock" SourceObjectName="UnitsInStock" Visible="true"/>
					<PropertyDefinition Name="Discontinued" SourceObjectName="Discontinued" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="QuarterlyOrders" RelativeNamespace="" SourceObjectName="dbo.Quarterly Orders" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="CustomerID" SourceObjectName="CustomerID" Visible="true"/>
					<PropertyDefinition Name="CompanyName" SourceObjectName="CompanyName" Visible="true"/>
					<PropertyDefinition Name="City" SourceObjectName="City" Visible="true"/>
					<PropertyDefinition Name="Country" SourceObjectName="Country" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="SalesbyCategory" RelativeNamespace="" SourceObjectName="dbo.Sales by Category" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="CategoryID" SourceObjectName="CategoryID" Visible="true"/>
					<PropertyDefinition Name="CategoryName" SourceObjectName="CategoryName" Visible="true"/>
					<PropertyDefinition Name="ProductName" SourceObjectName="ProductName" Visible="true"/>
					<PropertyDefinition Name="ProductSales" SourceObjectName="ProductSales" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="SalesTotalsbyAmount" RelativeNamespace="" SourceObjectName="dbo.Sales Totals by Amount" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="SaleAmount" SourceObjectName="SaleAmount" Visible="true"/>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="CompanyName" SourceObjectName="CompanyName" Visible="true"/>
					<PropertyDefinition Name="ShippedDate" SourceObjectName="ShippedDate" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="SummaryofSalesbyQuarter" RelativeNamespace="" SourceObjectName="dbo.Summary of Sales by Quarter" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="ShippedDate" SourceObjectName="ShippedDate" Visible="true"/>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="Subtotal" SourceObjectName="Subtotal" Visible="true"/>
				</Properties>
			</EntityDefinition>
			<EntityDefinition Name="SummaryofSalesbyYear" RelativeNamespace="" SourceObjectName="dbo.Summary of Sales by Year" IsAbstract="false" IsUpdatable="false" EntityType="Entity" SourceObjectType="View" Visible="true">
				<Properties>
					<PropertyDefinition Name="ShippedDate" SourceObjectName="ShippedDate" Visible="true"/>
					<PropertyDefinition Name="OrderID" SourceObjectName="OrderID" Visible="true"/>
					<PropertyDefinition Name="Subtotal" SourceObjectName="Subtotal" Visible="true"/>
				</Properties>
			</EntityDefinition>
		</Entities>
	</DomainDefinition>
	<BusinessLayerDefinition>
		<RelativeDomainLayerNamespace>Business.Entities</RelativeDomainLayerNamespace>
		<RelativeServiceLayerNamespace>Business.Services</RelativeServiceLayerNamespace>
		<Features>
			<SupportWCF>true</SupportWCF>
			<TargetCLRVersion>3.0</TargetCLRVersion>
			<TargetDatabase>SQL2005</TargetDatabase>
		</Features>
		<MetaData>
			<Entity>
				<Filename>$Domain.Model.RootPath$\$Domain.Model.BusinessLayer.RelativeDomainLayerNamespace$\$RelativeNamespace#Replace('.','\')$\$Name$</Filename>
				<GeneratedFilename>$Domain.Model.RootPath$\$Domain.Model.BusinessLayer.RelativeDomainLayerNamespace$\Generated\$RelativeNamespace#Replace('.','\')$\$Name$</GeneratedFilename>
			</Entity>
			<Service>
				<Filename>$Model.RootPath$\$Model.BusinessLayer.RelativeServiceLayerNamespace$\$RelativeNamespace#Replace('.','\')$\$Name$</Filename>
				<GeneratedFilename>$Model.RootPath$\$Model.BusinessLayer.RelativeServiceLayerNamespace$\Generated\$RelativeNamespace#Replace('.','\')$\$Name$</GeneratedFilename>
				<InterfaceName>I$Name$</InterfaceName>
				<InterfaceFilename>$Model.RootPath$\$Model.BusinessLayer.RelativeServiceLayerNamespace$.Interfaces\$RelativeNamespace#Replace('.','\')$\I$Name$</InterfaceFilename>
				<InterfaceGeneratedFilename>$Model.RootPath$\$Model.BusinessLayer.RelativeServiceLayerNamespace$.Interfaces\Generated\$RelativeNamespace#Replace('.','\')$\I$Name$</InterfaceGeneratedFilename>
				<InterfaceRelativeNamespace>Business.Services.Interfaces.$RelativeNamespace$</InterfaceRelativeNamespace>
			</Service>
			<ServiceDomain>
				<Filename>$RootPath$\$BusinessLayer.RelativeServiceLayerNamespace$</Filename>
				<GeneratedFilename>$RootPath$\$BusinessLayer.RelativeServiceLayerNamespace$\Generated</GeneratedFilename>
			</ServiceDomain>
			<ServiceMethods>
				<!-- ServiceMethodTypes: Unknown, RetrieveSingle, RetrieveMultiple, RetrieveManyToMany, RetrieveHierarchy, StoreSingle, StoreMultiple, StoreManyToMany, DeleteSingle, DeleteMultiple -->
				<ServiceMethodMetaDataDefinition ServiceType="RetrieveSingle">
					<FunctionName>gfn_Retrieve$Name$</FunctionName>
					<StoredProcedureName>gsp_Retrieve$Name$</StoredProcedureName>
					<MethodName>Retrieve$Entity.Name$</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="RetrieveMultiple">
					<FunctionName>gfn_$Name$Search</FunctionName>
					<StoredProcedureName>gsp_$Name$Search</StoredProcedureName>
					<MethodName>$Entity.Name$Search</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="RetrieveManyToMany">
					<FunctionName>gfn_Retrieve$Parent.Name$$Name$</FunctionName>
					<StoredProcedureName>gsp_Retrieve$Name$</StoredProcedureName>
					<MethodName>Retrieve$Name$</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="RetrieveHierarchy">
					<FunctionName>gfn_Retrieve$Name$</FunctionName>
					<StoredProcedureName>gsp_Retrieve$Name$</StoredProcedureName>
					<MethodName>Retrieve$Entity.Name$</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="StoreSingle">
					<FunctionName></FunctionName>
					<StoredProcedureName>gsp_$Name$Store</StoredProcedureName>
					<MethodName>$Entity.Name$Store</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="StoreMultiple">
					<FunctionName></FunctionName>
					<StoredProcedureName>gsp_$Name$sStore</StoredProcedureName>
					<MethodName>$Entity.Name$sStore</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="StoreManyToMany">
					<FunctionName></FunctionName>
					<StoredProcedureName>gsp_$Parent.Name$$RelatedEntity.Name$Store</StoredProcedureName>
					<MethodName>$Parent.Name$$RelatedEntity.Name$Store</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="StoreManyToManyMultiple">
					<FunctionName></FunctionName>
					<StoredProcedureName>gsp_$Parent.Name$$Name$Store</StoredProcedureName>
					<MethodName>$Parent.Name$$Name$Store</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="DeleteSingle">
					<FunctionName></FunctionName>
					<StoredProcedureName>gsp_$Name$Delete</StoredProcedureName>
					<MethodName>$Entity.Name$Delete</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
				<ServiceMethodMetaDataDefinition ServiceType="DeleteMultiple">
					<FunctionName>gfn_$Name$Delete</FunctionName>
					<StoredProcedureName>gsp_$Name$sDelete</StoredProcedureName>
					<MethodName>$Entity.Name$sDelete</MethodName>
					<Role></Role>
				</ServiceMethodMetaDataDefinition>
			</ServiceMethods>
		</MetaData>
		<BusinessServiceDefinitions>
			<BusinessServiceDefinition Name="Category" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Categories" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="CustomerDemographic" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.CustomerDemographics" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Customer" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Customers" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Employee" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Employees" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="OrderDetail" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Order Details" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Order" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Orders" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Product" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Products" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Region" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Region" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Shipper" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Shippers" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Supplier" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Suppliers" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="Territory" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Territories" IncludeHardDelete="false" IncludeRelatedEntities="true" IncludeRetrieveSingle="true" IncludeRetrieveMultiple="true" IncludeSoftDelete="false" IncludeStore="true" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
			<BusinessServiceDefinition Name="NeedsSorting" RelativeNamespace="">
				<ExposedEntities>
					<ExposedEntityDefinition SourceObjectName="dbo.Alphabetical list of products" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Category Sales for 1997" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Current Product List" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Customer and Suppliers by City" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Invoices" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Order Details Extended" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Order Subtotals" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Orders Qry" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Product Sales for 1997" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Products Above Average Price" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Products by Category" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Quarterly Orders" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Sales by Category" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Sales Totals by Amount" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Summary of Sales by Quarter" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
					<ExposedEntityDefinition SourceObjectName="dbo.Summary of Sales by Year" IncludeHardDelete="false" IncludeRelatedEntities="false" IncludeRetrieveSingle="false" IncludeRetrieveMultiple="false" IncludeSoftDelete="false" IncludeStore="false" />
				</ExposedEntities>
				<ServiceMethods />
			</BusinessServiceDefinition>
		</BusinessServiceDefinitions>
	</BusinessLayerDefinition>
</ModelDefinition>

